Project Objectives List

This article provides all the Fields available for each View currently available under the Project Objectives List Data Source in Upland Analytics.

The following Views are available when Project Objectives List Data Source is selected upon creating a report. Click on any of them to view the available Fields.

Portfolio - Project Portfolio
Program
Project
Project Alignment Objectives
Project Alignment Objective Types
Project Work Plan
Resource - Project Owner
User Permissions - Projects

 

Portfolio - Project Portfolio

Field Name	Description	Type
Created By	The ID number of the resource that created the project's portfolio.	A
Created Date	The date the project's portfolio was created, formatted (mm/dd/yyyy) with time.
Created Date Month Year	The date the project's portfolio was created, formatted by month and year.
Created Date Quarter Year	The date the project's portfolio was created, formatted by annual quarter and year.
Created Date Year	The year the project's portfolio was created.
Modified By	The ID number of the resource who modified the project's portfolio.	A
Modified Date	The date the project's portfolio was modified, formatted (mm/dd/yyyy) with time.
Modified Date Month Year	The date the project's portfolio was modified, formatted by month and year.
Modified Date Quarter Year	The date the project's portfolio was modified, formatted by annual quarter and year.
Modified Date Year	This is the year the project's portfolio was modified.
Portfolio Id	This is the id of the project's portfolio.	A
Portfolio Name	This is the name of the project's portfolio.	A

 

Program

Field Name	Description	Type
Created By	This is the project's program creator ID.	A
Created Date	The date the Program was created, formatted as mm/dd/yyyy with a timestamp.
Created Date Date	The date the Program was created, formatted as mm/dd/yyyy without a timestamp.
Created Date Month Year	The month and the year that the Program was created.
Created Date Quarter Year	The fiscal quarter and the year that the Program was created.
Created Date Year	The year that the Program was created.
Created Date Week	The week that the Program was created.
Description	This is the program description.	A
Modified By	This is the program modifier.	A
Modified Date	The date the Program was last modified, formatted as mm/dd/yyyy with a timestamp.
Modified Date Date	The date the Program was last modified, formatted as mm/dd/yyyy without a timestamp.
Modified Date Month Year	The month and the year that the Program was last modified.
Modified Date Quarter Year	The fiscal quarter and the year that the Program was last modified.
Modified Date Year	The year that the Program was last modified.
Modified Date Week	The week that the Program was last modified.
Name (Text)	This is the program name.	A
Name (URL)	This is the URL link to the program.	A
Number	This is the program number.	#
Organization Owner	This is the organization owner.	A
Owner	This is the program owner.	A
Portfolio	This is the name of the portfolio associated to the program.	A
Program Id	This is the Id of the program.	A
Program Last Status Update	The date (mm/dd/yyyy) and time the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators.
Program Last Status Update Week	The week the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators.
Status	This is the status of the program.	A
Program Status Update	The Program's current Status Update (not to be confused with Status).	A
Status Type	This is the status type of the program.	A
Status Type Id	This is the status type Id of the program.	A

 

Project

Field Name	Description	Type
Business Priority	This is the project business priority.	A
Category	This is the project category.	A
Category Sort Order	This is the project category sort order.	A
Created By	Project creator ID.	A
Created Date	The date the Project was created, formatted as mm/dd/yyyy with a timestamp.
Created Date Date	The date the Project was created, formatted as mm/dd/yyyy without a timestamp.
Created Date Month Year	The month and the year the Project was created.
Created Date Quarter Year	The fiscal quarter and the year the Project was created.
Created Date Year	The year the Project was created.
Created Date Week	The week the Project was created.
Description	This is the project description.	A
Last Status Update	This is the date and time of the project's last status update.
Modified By	This is the project modifier.	A
Modified Date	The date the Project was last modified, formatted as mm/dd/yyyy with a timestamp.
Modified Date Date	The date the Project was last modified, formatted as mm/dd/yyyy without a timestamp.
Modified Date Month Year	The month and the year the Project was last modified.
Modified Date Quarter Year	The fiscal quarter and the year the Project was last modified.
Modified Date Year	The year the Project was last modified.
Modified Date Week	The week the Project was last modified.
Name (Text)	This is the project name.	A
Name (URL)	This is the project name. It links directly to the project summary page.	A
Number	This is the project number.	A
Operations	This is the project operation.	A
Organization Owner	This is the project organization owner.	A
Owner Id	This is the Id of the owner.	A
Portfolio	This is the name of the portfolio associated to the project.	A
Priority	This is the project priority.	A
Priority Sort Order	This is the project priority sort order.	A
Program	This is the name of the program.	A
Project Id	This is the ID number of the project.	A
Project Status Id	This is the ID number of the project's current status.
Status	This is the current project status.
Status Id	This is the ID number of the project's current status.	A
Status Sort Order	This is the where the project's current status is listed in the status sort order.	A
Status Type	This is the project status type.	A
Status Type Id	This is the ID number of the project's status type.	A
Status Update	This is the project's most recent status update. Note that this could take up a lot of space in the report.	A
Type	This is the project's type.	A

 

Project Alignment Objectives

Field Name	Description	Type
Actual Effort	This is the actual effort of the project alignment objectives.	#
Allocated Effort	This is the allocated effort of the project alignment objectives.	#
Budget	This is the budget of the project.	#
Expected Benefits	This is the expected benefits of the project.	#
Expenditures	This is the expenditures of the project.	#
Objective Id	This is the objective Id of the project.	A
Planned Effort	This is the planned effort of the project.	#
Project Id	This is the project Id.	A
Realized Benefits	This is the realized benefits of the project.	#
Weight	This is the weight of the project.	A

 

Project Alignment Objective Types

Field Name	Description	Type
Created By	This is the creator Id.	A
Created Date	This is the creation date.
Current	This is the current project alignment objective type.	A
Description	This is the description of the project alignment objective type.	A
Modified By	This is the modifier of the project alignment objective type.	A
Modified Date	This is the modification date of the project alignment objective type.
Sort Order	This is the sort order of the project alignment objective type.	A
Type Id	This is the Id of the project alignment objective type.	A

 

Project Work Plan

Field Name	Description	Type
Actual Effort	This is the actual effort of the project workplan.	#
Actual Effort To Date	This is the actual effort to date of the project workplan.
Actual Effort To Date Vs Allocated Effort To Date	This is the actual effort to date vs allocated effort to date of the project workplan.
Allocated Effort	This is the allocated effort of the project workplan.	#
Allocated Effort To Date	This is the allocated effort to date of the project workplan.
Baseline Duration	This is the baseline duration of the project workplan.	#
Baseline End Date	This is the baseline end date of the project workplan, formatted (mm/dd/yyyy).
Baseline End Date Month Year	This is the baseline end date of the project workplan, formatted by month and year.
Baseline End Date Quarter Year	This is the baseline end date of the project workplan, formatted by annual quarter and year.
Baseline End Date Year	This is the year of the workplan's baseline end date.
Baseline Start Date	This is the baseline start date of the project workplan, formatted (mm/dd/yyyy).
Baseline Start Date Month Year	This is the baseline start date of the project workplan, formatted by month and year.
Baseline Start Date Quarter Year	This is the baseline start date of the project workplan, formatted by annual quarter and year.
Baseline Start Date Year	This is the year of the workplan's baseline start date.
Checkout Date	This is the most recent checkout date of the project workplan, formatted (mm/dd/yyyy) with time.
Checkout Date Month Year	This is the most recent date of the project workplan, formatted by month and year.
Checkout Date Quarter Year	This is the most recent checkout date of the project workplan, formatted by annual quarter and year.
Checkout Date Year	This is the year the project workplan was last checked out.
Checkout User Id	This is the ID number of the resource who most recently checked out the project workplan.	A
Completed Through Date	This is the "completed through" date of the project workplan, formatted (mm/dd/yyyy).
Completed Through Date Month Year	This is the "completed through" date of the project workplan, formatted by month and year.
Completed Through Date Quarter Year	This is the "completed through" date of the project workplan, formatted by annual quarter and year.
Completed Through Date Year	This is the "completed through" year of the project workplan.
Current End Vs Baseline End	This is the current end vs baseline end of the project workplan.	#
Current Workplan Id	This is the current Id of the workplan.	#
Duration	This is the duration of the project workplan.	#
End Date	This is the end date of the project workplan, formatted (mm/dd/yyyy).
End Date Month Year	This is the end date of the project workplan, formatted by month and year.
End Date Quarter Year	This is the end date of the project workplan, formatted by annual quarter and year.
End Date Year	This is the year of the project workplan's end date.
Expected Work Complete	This is the expected work complete of the project workplan.	A
Expected Work Complete Critical	This is the expected work complete critical of the project workplan.	A
Progress	This is the progress of the project workplan.	A
Project Id	This is the ID number of the project.	A
Project Workplan Created By	This is the ID number of the Resource who created the Work Plan.	A
Project Workplan Created Date	This is the date the Work Plan was created, formatted (mm/dd/yyyy) with time.
Project Workplan Modified By	This is the ID number of the Resource who last modified the Work Plan	A
Project Workplan Modified Date	This is the date the Work Plan was last modified, formatted (mm/dd/yyyy) with time.
Resource Productivity Ratio	This is the resource productivity ratio of the project workplan.	#
Start Date	This is the start date of the project workplan, formatted (mm/dd/yyyy).
Start Date Month Year	This is the start date of the project workplan, formatted by month and year.
Start Date Quarter Year	This is the start date of the project workplan, formatted by annual quarter and year.
Start Date Year	This is the year of the project workplan's start date.
Variance Days	This is the variance days of the project workplan.
Work Complete	This is the work complete of the project workplan.	A
Work Complete Critical	This is the work complete critical of the project workplan.	A

 

Resource - Project Owner

Field Name	Description	Type
Created Date Month Year	This is the date the project owner was created as a resource, formatted by month and year.
Created Date Quarter Year	This is the date the project owner was created as a resource, formatted by annual quarter and year.
Created Date Year	This is the year the project owner was created as a resource.
Email	This is the email of the project owner.	A
First Name	This is the first name of the project owner.	A
Last Name	This is the last name of the project owner.	A
Modified Date Month Year	This is the date the project owner was modified as a resource, formatted by month and year.
Modified Date Quarter Year	This is the date the project owner was modified as a resource, formatted by annual quarter and year.
Modified Date Year	This is the year the project owner was modified as a resource.
Name (URL)	This is the URL link to the project owner.	A
Resource Id	This is the resource ID number of the project owner.	A
Status	This is the status of the project owner.	A

 

User Permissions - Projects

Field Name	Description	Type
User Account Type	This is the account type of the user.	A
User Chat Id	This is the chat ID of the user.	A
User Created By	This is the ID of the creator.	#
User Created Date	This is the date the user was created.	A
User Email	This is the email address of the user.	A
User Employee Id	This is the employee ID of the user.	A
User Ext	This is the phone number extension of the user.	A
User Fax	This is the fax number of the user.	A
User First Name	This is the first name of the user.	A
User Handle	This is the "@" handle of the user.	A
User Id	This is the ID of the user.	#
User Initials	These are the initials of the user.	A
User Is Active	This indicates whether or not the user is active.	A
User Last Name	This is the last name of the user.	A
User Login	This is the login/username email of the user.	A
User Modified By	This is the ID of the most recent modifier of the user.	#
User Modified Date	This is the date of the most recent modification of the user.	A
User Phone	This is the phone number of the user.	A
User URL	This is the name of the user, which is a link to the user's profile.	A